/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : localhost:3306
 Source Schema         : dev_utf8

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 15/10/2020 11:19:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ic_alarm_statistics
-- ----------------------------
DROP TABLE IF EXISTS `ic_alarm_statistics`;
CREATE TABLE `ic_alarm_statistics`
(
    `id`            bigint(20) NOT NULL AUTO_INCREMENT,
    `create_time`   datetime     DEFAULT NULL,
    `creator`       varchar(255) DEFAULT NULL,
    `update_time`   datetime     DEFAULT NULL,
    `alarm_type`    int(11)      DEFAULT NULL,
    `date`          datetime     DEFAULT NULL,
    `ignore_count`  int(11)      DEFAULT NULL,
    `total_count`   int(11)      DEFAULT NULL,
    `total_handled` int(11)      DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 45
  DEFAULT CHARSET = utf8;

-- ----------------------------
-- Records of ic_alarm_statistics
-- ----------------------------
BEGIN;
INSERT INTO `ic_alarm_statistics`
VALUES (1, '2020-10-15 11:02:56', NULL, '2020-10-15 11:02:56', NULL, '2020-07-01 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (2, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-02 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (3, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-03 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (4, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-04 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (5, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-05 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (6, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-06 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (7, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-07 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (8, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-08 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (9, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-09 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (10, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-10 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (11, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-11 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (12, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-12 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (13, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-13 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (14, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-14 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (15, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-15 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (16, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-16 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (17, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-17 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (18, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-18 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (19, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-19 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (20, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-20 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (21, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-21 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (22, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-22 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (23, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-23 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (24, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-24 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (25, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-25 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (26, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-26 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (27, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-27 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (28, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-28 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (29, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-29 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (30, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-07-30 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (31, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-01 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (32, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-02 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (33, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-03 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (34, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-04 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (35, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-05 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (36, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-06 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (37, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-07 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (38, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-08 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (39, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-09 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (40, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-10 00:00:00', 0, 2, 2);
INSERT INTO `ic_alarm_statistics`
VALUES (41, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-11 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (42, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-12 00:00:00', 11, 11, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (43, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-13 00:00:00', 0, 0, 0);
INSERT INTO `ic_alarm_statistics`
VALUES (44, '2020-10-15 11:02:58', NULL, '2020-10-15 11:02:58', NULL, '2020-10-14 00:00:00', 3, 4, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
